Offline Grid Edit

You can make offline edits to exported .xlsx files from the UIs and UIOs grids in Curriculum Manager. This functionality is enabled by the EBS4OfflineEdit licence.

To export, edit and import a .xlsx file in Curriculum Manager:

  1. Click the Export Data button in the grid toolbar in the UIs or UIOs grid in Curriculum Manager.

    Grid toolbar - Export Data button

    The Export Settings window is displayed.

    Export Settings

  2. Select the export settings needed, making sure to select Offline Edit Data from the Export Type field.

    Note: The export format can only be set to Excel 2007+ (.XLSX) Format when using the offline grid edit functionality.

  3. Click the OK button to save the export file.

    The export file will open in the default spreadsheet application.

  4. Edit the export file with the required changes.

    Note: Users can only amend the same editable fields from the UIs or UIOs grid. Any locked fields will be read-only in the export file.

  5. Save the export file.

  6. Click the Import Data button in the grid toolbar in the UIs or UIOs grid in Curriculum Manager.

    Grid toolbar - Import Data button

  7. Navigate to and select the required file to import on the Open window that is displayed, and then click Open.

    The Import Results window is displayed with the results of the import and the amount of changes made.

    Import Results window

  8. Click the Close button.

    The rows that have been edited are displayed in the relevant grid in Curriculum Manager, with the changes made displayed in green.

  9. Click Save.

    The changes are imported into ebs: central.

Back to top